object fmOnaylanmamisMalzemeFisiAktar: TfmOnaylanmamisMalzemeFisiAktar
  Left = 143
  Top = 130
  Width = 989
  Height = 545
  Caption = 'Onaylanmam'#305#351' Malzeme Fi'#351'leri'
  Color = clBtnFace
  Font.Charset = TURKISH_CHARSET
  Font.Color = clWindowText
  Font.Height = -11
  Font.Name = 'Arial'
  Font.Style = []
  OldCreateOrder = False
  Position = poScreenCenter
  OnClose = FormClose
  OnCreate = FormCreate
  OnShow = FormShow
  PixelsPerInch = 96
  TextHeight = 14
  object wwDBGrid1: TwwDBGrid
    Left = 0
    Top = 77
    Width = 981
    Height = 344
    DisableThemes = False
    ControlType.Strings = (
      'UnityAktarim;CheckBox;True;False')
    Selected.Strings = (
      'id'#9'6'#9'Fi'#351' No'
      'tarih'#9'10'#9'Tarih'
      'saat'#9'5'#9'Saat'
      'Tipi'#9'5'#9'Tipi'#9'F'
      'fisadi'#9'20'#9'Fi'#351' T'#252'r'#252#9'F'
      'belgeno'#9'10'#9'Belgeno'
      'cambaradi'#9'14'#9#199#305'kan Ambar'#9'F'
      'gambaradi'#9'14'#9'Giren Ambar'#9'F'
      'aciklama'#9'30'#9'A'#231#305'klama'
      'GCDepo'#9'11'#9'GCDepo'#9'F'
      'uretimEmriNo'#9'10'#9'Emir No'#9'F'
      'UnityAktarim'#9'6'#9'Unt.Akt.'#9'F')
    IniAttributes.Delimiter = ';;'
    TitleColor = clBtnFace
    FixedCols = 0
    ShowHorzScrollBar = True
    Align = alClient
    DataSource = ListeQS
    KeyOptions = []
    Options = [dgTitles, dgIndicator, dgColumnResize, dgColLines, dgRowLines, dgTabs, dgRowSelect, dgAlwaysShowSelection, dgConfirmDelete, dgCancelOnExit, dgWordWrap]
    PopupMenu = PopupMenu1
    TabOrder = 0
    TitleAlignment = taLeftJustify
    TitleFont.Charset = TURKISH_CHARSET
    TitleFont.Color = clWindowText
    TitleFont.Height = -11
    TitleFont.Name = 'Arial'
    TitleFont.Style = []
    TitleLines = 1
    TitleButtons = False
    UseTFields = False
  end
  object Panel1: TPanel
    Left = 0
    Top = 47
    Width = 981
    Height = 30
    Align = alTop
    BevelOuter = bvNone
    TabOrder = 1
    object Label1: TLabel
      Left = 8
      Top = 8
      Width = 61
      Height = 14
      Caption = 'Malzeme Fi'#351'i'
      Transparent = True
    end
    object MalzemeFisik: TwwDBComboBox
      Left = 80
      Top = 4
      Width = 209
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        'Ambar Fi'#351'i'#9'61'
        #220'retim Giri'#351' Fi'#351'i'#9'01'
        'Sarf Fi'#351'i'#9'21'
        'Par'#231'a De'#287'i'#351'im Ambar Fi'#351'i'#9'00'
        'Par'#231'a De'#287'i'#351'im '#220'retim-Sarf Fi'#351'i'#9'PD'
        'Ek Par'#231'a Fi'#351'i'#9'XX'
        'Uretim Ar'#305'za Fi'#351'i'#9'YY'
        'RMA Giri'#351' Fi'#351'i'#9'02'
        'RMA '#199#305'k'#305#351' Fi'#351'i'#9'22'
        'Say'#305'm Eksi'#287'i Fi'#351'i'#9'23'
        'Say'#305'm Fazlas'#305' Fi'#351'i'#9'03'
        #220'r'#252'n Nakil Fi'#351'i'#9'UN'
        #220'r'#252'n Par'#231'alama Fi'#351'i'#9'UP'
        'Ters '#220'retim Fi'#351'i'#9'TU')
      Sorted = False
      TabOrder = 0
      UnboundDataType = wwDefault
      OnChange = MalzemeFisikChange
    end
    object cbAktarimTip: TwwDBComboBox
      Left = 781
      Top = 4
      Width = 100
      Height = 22
      ShowButton = True
      Style = csDropDownList
      MapList = True
      AllowClearKey = True
      AutoDropDown = True
      DropDownCount = 8
      ItemHeight = 0
      Items.Strings = (
        #220'retim Giri'#351' Fi'#351'i'#9'01'
        'Sarf Fi'#351'i '#220'retim'#9'21'
        'Ambar Fi'#351'i'#9'61'
        'Par'#231'a De'#287'i'#351'im Ambar Fi'#351'i'#9'00'
        'Par'#231'a De'#287'i'#351'im '#220'retim-Sarf Fi'#351'i'#9'PD'
        'Ek Par'#231'a Fi'#351'i'#9'XX'
        'Uretim Ar'#305'za Fi'#351'i'#9'YY'
        'RMA Giri'#351' Fi'#351'i'#9'02'
        'RMA '#199#305'k'#305#351' Fi'#351'i'#9'22'
        'Say'#305'm Eksi'#287'i Fi'#351'i'#9'23'
        'Say'#305'm Fazlas'#305' Fi'#351'i'#9'03'
        #220'r'#252'n Nakil Fi'#351'i'#9'UN'
        #220'r'#252'n Par'#231'alama Fi'#351'i'#9'UP'
        'Ters '#220'retim Fi'#351'i'#9'TU')
      ItemIndex = 0
      Sorted = False
      TabOrder = 1
      UnboundDataType = wwDefault
      Visible = False
      OnChange = MalzemeFisikChange
    end
    object cbOtoAktar: TCheckBox
      Left = 326
      Top = 6
      Width = 117
      Height = 17
      Caption = 'Otomatik Aktar'#305'm'
      Checked = True
      State = cbChecked
      TabOrder = 2
    end
    object OtoAktarSn: TSpinEdit
      Left = 442
      Top = 3
      Width = 62
      Height = 23
      MaxValue = 0
      MinValue = 0
      TabOrder = 3
      Value = 300
    end
  end
  object Panel2: TPanel
    Left = 0
    Top = 421
    Width = 981
    Height = 35
    Align = alBottom
    BevelOuter = bvNone
    TabOrder = 2
    DesignSize = (
      981
      35)
    object bkapat: TBitBtn
      Left = 898
      Top = 6
      Width = 75
      Height = 25
      Anchors = [akRight, akBottom]
      Caption = 'Kapat'
      TabOrder = 0
      OnClick = bkapatClick
    end
    object bonayla: TBitBtn
      Left = 4
      Top = 6
      Width = 112
      Height = 25
      Caption = 'Onayla'
      Enabled = False
      TabOrder = 1
      OnClick = bonaylaClick
    end
    object bReceteAktar: TBitBtn
      Left = 115
      Top = 6
      Width = 22
      Height = 25
      Caption = 'Re'#231'ete Olarak Aktar'
      Enabled = False
      TabOrder = 2
      Visible = False
      OnClick = bReceteAktarClick
    end
    object btListele: TBitBtn
      Left = 139
      Top = 6
      Width = 100
      Height = 25
      Action = acListele
      Caption = 'Listele'
      TabOrder = 3
    end
  end
  object GroupBox1: TGroupBox
    Left = 0
    Top = 0
    Width = 981
    Height = 47
    Align = alTop
    Caption = 'Unity '#350'irket Ayar'#305
    Font.Charset = TURKISH_CHARSET
    Font.Color = clWindowText
    Font.Height = -11
    Font.Name = 'Arial'
    Font.Style = [fsBold]
    ParentFont = False
    TabOrder = 3
    object Label14: TLabel
      Left = 6
      Top = 19
      Width = 66
      Height = 14
      Caption = 'Kullan'#305'c'#305' Ad'#305
      Transparent = True
    end
    object Label15: TLabel
      Left = 217
      Top = 19
      Width = 26
      Height = 14
      Caption = #350'ifre'
      Transparent = True
    end
    object bbaglan: TButton
      Left = 378
      Top = 12
      Width = 85
      Height = 29
      HelpType = htKeyword
      Caption = 'Ba'#287'lan'
      Font.Charset = TURKISH_CHARSET
      Font.Color = clWindowText
      Font.Height = -13
      Font.Name = 'Arial'
      Font.Style = [fsBold]
      ParentFont = False
      TabOrder = 2
      OnClick = bbaglanClick
    end
    object usernamek: TEdit
      Left = 80
      Top = 16
      Width = 121
      Height = 22
      HelpType = htKeyword
      HelpKeyword = 'UserName'
      TabOrder = 0
      Text = 'fethi'
    end
    object Passwordk: TEdit
      Left = 251
      Top = 16
      Width = 121
      Height = 22
      HelpType = htKeyword
      HelpKeyword = 'UserPassword'
      PasswordChar = '*'
      TabOrder = 1
    end
  end
  object StBar: TfcStatusBar
    Left = 0
    Top = 456
    Width = 981
    Height = 20
    Panels = <
      item
        Font.Charset = TURKISH_CHARSET
        Font.Color = clWindowText
        Font.Height = -11
        Font.Name = 'Arial'
        Font.Style = []
        Name = 'Panel0'
        Tag = 0
        TextOptions.Alignment = taLeftJustify
        TextOptions.VAlignment = vaVCenter
        Width = '50'
      end>
    SimplePanel = False
    StatusBarText.CapsLock = 'Caps'
    StatusBarText.Overwrite = 'Overwrite'
    StatusBarText.NumLock = 'Num'
    StatusBarText.ScrollLock = 'Scroll'
  end
  object Panel3: TPanel
    Left = 0
    Top = 476
    Width = 981
    Height = 42
    Align = alBottom
    TabOrder = 5
    Visible = False
    object Label2: TLabel
      Left = 13
      Top = 15
      Width = 23
      Height = 14
      Caption = 'Tarih'
      Transparent = True
    end
    object Label3: TLabel
      Left = 135
      Top = 15
      Width = 4
      Height = 14
      Caption = '-'
      Transparent = True
    end
    object Date1: TwwDBDateTimePicker
      Left = 42
      Top = 12
      Width = 92
      Height = 22
      TabStop = False
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 0
      UnboundDataType = wwDTEdtDate
    end
    object Date2: TwwDBDateTimePicker
      Left = 141
      Top = 12
      Width = 95
      Height = 22
      TabStop = False
      CalendarAttributes.Font.Charset = DEFAULT_CHARSET
      CalendarAttributes.Font.Color = clWindowText
      CalendarAttributes.Font.Height = -11
      CalendarAttributes.Font.Name = 'MS Sans Serif'
      CalendarAttributes.Font.Style = []
      Epoch = 1950
      ShowButton = True
      TabOrder = 1
      UnboundDataType = wwDTEdtDate
    end
    object btOzelkodAktar: TButton
      Left = 239
      Top = 5
      Width = 97
      Height = 33
      Caption = #220'retim Emri     '#214'zel Kod Aktar'
      Enabled = False
      TabOrder = 2
      TabStop = False
      WordWrap = True
      OnClick = btOzelkodAktarClick
    end
    object btLogoStokFisiDegistir: TButton
      Left = 368
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Logo StokFi'#351'i De'#287'i'#351'tir'
      Enabled = False
      TabOrder = 3
      TabStop = False
      WordWrap = True
      OnClick = btLogoStokFisiDegistirClick
    end
    object btLogoStokKoduDegistir: TButton
      Left = 464
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Logo Stokkodu De'#287'i'#351'tir'
      Enabled = False
      TabOrder = 4
      TabStop = False
      WordWrap = True
      OnClick = btLogoStokKoduDegistirClick
    end
    object btLogoStokKoduSil: TButton
      Left = 664
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Logo Stokkodu Sil'
      Enabled = False
      TabOrder = 5
      TabStop = False
      WordWrap = True
      OnClick = btLogoStokKoduSilClick
    end
    object btUnitydeOlmayanGuncelle: TButton
      Left = 761
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Unity de Olmayan Stoklar'#305' G'#252'ncelle'
      Enabled = False
      TabOrder = 6
      TabStop = False
      WordWrap = True
      OnClick = btUnitydeOlmayanGuncelleClick
    end
    object btPrgStokkoduDegistir: TButton
      Left = 560
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Prg Stokkodu De'#287'i'#351'tir'
      Enabled = False
      TabOrder = 7
      TabStop = False
      WordWrap = True
      OnClick = btPrgStokkoduDegistirClick
    end
    object btUnityStokEanGuncelle: TButton
      Left = 858
      Top = 5
      Width = 97
      Height = 33
      Caption = 'Unity Stok Ean Barkod G'#252'ncelle '
      Enabled = False
      TabOrder = 8
      TabStop = False
      WordWrap = True
      OnClick = btUnityStokEanGuncelleClick
    end
  end
  object ListeQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    Prepared = True
    SQL.Strings = (
      
        'select *,fisadi=(select fisadi from P_StokFisi_Fisadi p where p.' +
        'fistipi=stokfisi.fistipi),gambaradi=dbo.GetAmbar(gambar),cambara' +
        'di=dbo.GetAmbar(cambar) from stokfisi'
      'where onayla is null and fistipi='#39'61'#39' '
      'order by id')
    Left = 256
    Top = 157
  end
  object ListeQS: TDataSource
    DataSet = ListeQ
    Left = 464
    Top = 149
  end
  object DepolarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'Select * from depolar Where Aktif=1')
    Left = 432
    Top = 77
  end
  object ListeHarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'stokfisid'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'select * from stokfisihar where stokfisid=:stokfisid')
    Left = 296
    Top = 77
  end
  object islemionaylaQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'stokfisid'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'select * from stokfisihar where stokfisid=:stokfisid')
    Left = 352
    Top = 77
  end
  object CUretimBulQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'Select * from depolar Where Aktif=1')
    Left = 136
    Top = 77
  end
  object CUremriHarQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    SQL.Strings = (
      'Select * from depolar Where Aktif=1')
    Left = 504
    Top = 77
  end
  object PopupMenu1: TPopupMenu
    Left = 120
    Top = 248
    object GnnTarihiniAta1: TMenuItem
      Caption = 'G'#252'n'#252'n Tarihini Ata'
      OnClick = GnnTarihiniAta1Click
    end
  end
  object TarihDuzelltQ: TADOQuery
    Connection = dm.connect
    Parameters = <>
    Left = 200
    Top = 80
  end
  object adoTemp: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    SQL.Strings = (
      
        'select *,fisadi=(select fisadi from P_StokFisi_Fisadi p where p.' +
        'fistipi=stokfisi.fistipi),gambaradi=dbo.GetAmbar(gambar),cambara' +
        'di=dbo.GetAmbar(cambar) from stokfisi'
      'where onayla is null and fistipi='#39'61'#39
      'order by id')
    Left = 88
    Top = 157
  end
  object adoUnity: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 263
    Top = 277
  end
  object adoListehar: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'stokfisid'
        Size = -1
        Value = Null
      end>
    SQL.Strings = (
      'select * from stokfisihar where stokfisid=:stokfisid')
    Left = 312
    Top = 157
  end
  object URevizyonQ: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    LockType = ltBatchOptimistic
    Parameters = <>
    Left = 328
    Top = 277
  end
  object Unity_ServisQ: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <>
    Prepared = True
    Left = 424
    Top = 280
  end
  object Uremri: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'Emirno'
        Attributes = [paSigned]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'select u.*,s.unitystokkod from urEmri u'
      'left join stok s on u.stokkodu=s.Stokkodu'
      'where emirno=:Emirno')
    Left = 480
    Top = 256
  end
  object UrEmriHar: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'EmirNo'
        Attributes = [paSigned, paNullable]
        DataType = ftInteger
        Precision = 10
        Size = 4
        Value = Null
      end>
    SQL.Strings = (
      'select * from urEmriHar'
      'where emirno=:EmirNo'
      'order by urunck,stokkodu')
    Left = 528
    Top = 256
  end
  object adoUnity2: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 264
    Top = 341
  end
  object adoUnity3: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 328
    Top = 341
  end
  object adoUnity4: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 384
    Top = 341
  end
  object AdoUnityTemp: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 448
    Top = 341
  end
  object cnnnExcel: TADOConnection
    LoginPrompt = False
    Left = 688
    Top = 152
  end
  object adoExcel: TADOQuery
    Connection = cnnnExcel
    LockType = ltBatchOptimistic
    Parameters = <
      item
        Name = 'serinos'
        DataType = ftString
        NumericScale = 255
        Precision = 255
        Size = 50
        Value = Null
      end>
    SQL.Strings = (
      'select bilisnocik,makinano from fatharhar '
      'where serinos=:serinos')
    Left = 688
    Top = 208
  end
  object dsExcel: TDataSource
    DataSet = adoExcel
    Left = 688
    Top = 264
  end
  object OpenExcel: TOpenDialog
    DefaultExt = '.xls'
    Filter = 'Excel Dosylar'#305'|*.xls'
    Left = 688
    Top = 320
  end
  object AdoUnityTemp2: TADOQuery
    Connection = dm.Connect_Unity
    CursorType = ctStatic
    Parameters = <>
    Left = 512
    Top = 341
  end
  object Unity_Depolar: TADOQuery
    Connection = dm.connect
    CursorType = ctStatic
    Parameters = <
      item
        Name = 'FIRMNR'
        Attributes = [paSigned, paNullable]
        DataType = ftSmallint
        Precision = 5
        Size = 2
        Value = Null
      end>
    SQL.Strings = (
      'select NR,NAME,COSTGRP from WW_L_CAPIWHOUSE Where FIRMNR=:FIRMNR')
    Left = 202
    Top = 300
  end
  object ActionList1: TActionList
    Left = 631
    Top = 214
    object acListele: TAction
      Caption = 'Listele'
      ShortCut = 116
      OnExecute = MalzemeFisikChange
    end
  end
  object tmrAktarim: TTimer
    Enabled = False
    OnTimer = tmrAktarimTimer
    Left = 481
    Top = 215
  end
end
